|
|
Implementation of OLAP Analysis for BUT Libraries
Mahdalíček, Josef ; Ruttkay, Ladislav (referee) ; Šárfy, Martin (advisor)
The aim of this project is to create tool for OLAP analysis over operational data of BUT libraries. This OLAP tool answers ie. query how long were users having loaned books. These queries could be specified by time period (year, month), library (ie. FIT library) and other dimensions. Only some, for this application interesting, tables from source database are used. Tables were exported into text files in csv format. According to project specification, system for OLAP analysis should be open source. Tool Mondrian accomplishes this requirement and was used in this work. Data warehouse is represented by relational database MySQL. ETL tool feeds data warehouse by data from exported files. User interface is used from internet browser and is implemented by component JPivot. Query results are displayed in tables and graphs.
|
|
| |
|
|
Management of Information Flow of Small Software Company
Klimeš, Jiří ; Martoch, Zbyšek (referee) ; Kříž, Jiří (advisor)
This diploma thesis deals with the management of information flow of a small company using Business Intelligence tools and the data mart. There is defined the problem of working with information from the point of view of selected company in the first part. The next part presents selected theoretical background on the basis of which was the aim achieved. The fourth part analyses the current situation of the company. There is recommended complex improvement of the current situation in the practical part. Selected information management problem is accomplished factually. There are also introduced suitable software tools, which were used for the solution.
|
|
|
Concept of Business Intelligence Using for SME's
Stryka, Lukáš ; Soukup, Lukáš (referee) ; Videcká, Zdeňka (advisor)
This Diploma Thesis deals with analysis of the current processes in small software company. On the basis of the weakness evaluation, the new extensions of the information system are designed. The first extension is new module for on-line sale and cashless on-line payment. The second one is integration of Business Intelligence tools to help streamline marketing strategies of this company.
|
|
|
OLAP Recommender
Koukal, Bohuslav ; Chudán, David (advisor) ; Vojíř, Stanislav (referee)
Manual data exploration in data cubes and searching for potentially interesting and useful information starts to be time-consuming and ineffective from certain volume of the data. In my thesis, I designed, implemented and tested a system, automating the data cube exploration and offering potentially interesting views on OLAP data to the end user. The system is based on integration of two data analytics methods - OLAP analysis data visualisation and data mining, represented by GUHA association rules mining. Another contribution of my work is a research of possibilities how to solve differences between OLAP analysis and association rule mining. Implemented solutions of the differences include data discretization, dimensions commensurability, design of automatic data mining task algorithm based on the data structure and mapping definition between mined association rules and corresponding OLAP visualisation. The system was tested with real retail sales data and with EU structural funds data. The experiments proved that complementary usage of the association rule mining together with OLAP analysis identifies relationships in the data with higher success rate than the isolated use of both techniques.
|
|
|
Information System of a Restaurant
Lazarčík, Lukáš ; Zámečníková, Eva (referee) ; Jirák, Ota (advisor)
Contents of processed bachelor thesis is composed of information system for restaurants. Process includes requirements definition and complete analysis of possible solutions. It is followed by concrete design and its implementation. It is necessary to create an area for system of cashes and stock leadership. Second part contains important OLAP analysis part. There were used PHP programming language, HTML and JavaScript language throughout creation of the application. This application runs on server with support of MySQL relational database.
|
|
| |
|
|
Implementation of OLAP Analysis for BUT Libraries
Mahdalíček, Josef ; Ruttkay, Ladislav (referee) ; Šárfy, Martin (advisor)
The aim of this project is to create tool for OLAP analysis over operational data of BUT libraries. This OLAP tool answers ie. query how long were users having loaned books. These queries could be specified by time period (year, month), library (ie. FIT library) and other dimensions. Only some, for this application interesting, tables from source database are used. Tables were exported into text files in csv format. According to project specification, system for OLAP analysis should be open source. Tool Mondrian accomplishes this requirement and was used in this work. Data warehouse is represented by relational database MySQL. ETL tool feeds data warehouse by data from exported files. User interface is used from internet browser and is implemented by component JPivot. Query results are displayed in tables and graphs.
|
|
|
Management of Information Flow of Small Software Company
Klimeš, Jiří ; Martoch, Zbyšek (referee) ; Kříž, Jiří (advisor)
This diploma thesis deals with the management of information flow of a small company using Business Intelligence tools and the data mart. There is defined the problem of working with information from the point of view of selected company in the first part. The next part presents selected theoretical background on the basis of which was the aim achieved. The fourth part analyses the current situation of the company. There is recommended complex improvement of the current situation in the practical part. Selected information management problem is accomplished factually. There are also introduced suitable software tools, which were used for the solution.
|
|
|
Concept of Business Intelligence Using for SME's
Stryka, Lukáš ; Soukup, Lukáš (referee) ; Videcká, Zdeňka (advisor)
This Diploma Thesis deals with analysis of the current processes in small software company. On the basis of the weakness evaluation, the new extensions of the information system are designed. The first extension is new module for on-line sale and cashless on-line payment. The second one is integration of Business Intelligence tools to help streamline marketing strategies of this company.
|
guest ::
